﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true"
    CodeFile="ViewWorkOn4Lunch.aspx.cs" Inherits="WorkTime_ViewWorkOn4Lunch" %>

<%@ Register Src="../Control/DepartmentDList.ascx" TagName="DepartmentDList" TagPrefix="uc2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Titile" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" runat="Server">
    <infolight:webdatasource id="wsWorkOnCheck" runat="server" selectalias="Usasdb" selectcommand="SELECT  dbo.Employees.EmployeeID, dbo.Employees.EmpName, &#13;&#10;      dbo.Contract.Contractbegin, dbo.Contract.Contractend, &#13;&#10;      dbo.Department.DepartmentName, dbo.Contract.Remark, dbo.Employees.Accession, &#13;&#10;      FLOOR(DATEDIFF([Month], dbo.Employees.Accession, GETDATE()) / 12.0) &#13;&#10;      AS AccTime, YEAR(GETDATE()) AS YearData&#13;&#10;FROM dbo.Employees INNER JOIN&#13;&#10;      dbo.Contract ON dbo.Employees.EmployeeID = dbo.Contract.EmployeeID INNER JOIN&#13;&#10;      dbo.Department ON &#13;&#10;      dbo.Employees.DepartmentId = dbo.Department.DepartmentId&#13;&#10;WHERE (dbo.Contract.Overdue = 0) AND (dbo.Employees.EmpStatus = 1) &#13;&#10;ORDER BY dbo.Employees.EmployeeID"
        cachedataset="True">
    </infolight:webdatasource>
    <infolight:webdatasource id="wsDepartment" runat="server" selectalias="Usasdb" selectcommand="SELECT DepartmentId,DepartmentName &#13;&#10; FROM Department where Del=0 and DepartmentId >0 "
        cachedataset="True">
    </infolight:webdatasource>
    <table cellpadding="0" cellspacing="5" class="TbSearch">
        <tr>
            <td align="right" style="width: 58px;" valign="middle">
                <asp:Label ID="LLabel1" runat="server" Text="年份:" Width="40px"></asp:Label>
            </td>
            <td align="right" style="width: 50px;" valign="middle">
                <asp:DropDownList ID="DlYear" runat="server" Width="80px">
                      <asp:ListItem>2008</asp:ListItem>
                    <asp:ListItem>2009</asp:ListItem>
                    <asp:ListItem>2010</asp:ListItem>
                    <asp:ListItem Selected="True">2011</asp:ListItem>
                    <asp:ListItem>2012</asp:ListItem>
                    <asp:ListItem>2013</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td align="right" style="width: 52px;" valign="middle">
                <asp:Label ID="LLabel2" runat="server" Text="月份:" Width="40px"></asp:Label>
            </td>
            <td style="width: 73px;">
                <asp:DropDownList ID="DLMonth" runat="server" Width="72px">
                    <asp:ListItem Value="1">1月</asp:ListItem>
                    <asp:ListItem Value="2">2月</asp:ListItem>
                    <asp:ListItem Value="3">3月</asp:ListItem>
                    <asp:ListItem Value="4">4月</asp:ListItem>
                    <asp:ListItem Value="5">5月</asp:ListItem>
                    <asp:ListItem Value="6">6月</asp:ListItem>
                    <asp:ListItem Value="7">7月</asp:ListItem>
                    <asp:ListItem Value="8">8月</asp:ListItem>
                    <asp:ListItem Value="9">9月</asp:ListItem>
                    <asp:ListItem Value="10">10月</asp:ListItem>
                    <asp:ListItem Value="11">11月</asp:ListItem>
                    <asp:ListItem Value="12">12月</asp:ListItem>
                </asp:DropDownList>
            </td>
            <td align="right" style="width: 40px;">
                <asp:Label ID="LLabel3" runat="server" Text="组织部门:" Width="56px"></asp:Label>
            </td>
            <td align="center" style="width: 46px;">
                <uc2:DepartmentDList ID="DepartmentDList1" runat="server"></uc2:DepartmentDList>
            </td>
            <td align="center" style="width: 142px;">
            </td>
            <td style="width: 288px;">
                <span class="roundbtn">
                    <asp:LinkButton ID="Refresh" runat="server" Text="&nbsp;&nbsp;&nbsp;&nbsp;刷 新&nbsp;&nbsp;&nbsp;&nbsp;" OnClick="Refresh_Click"></asp:LinkButton>
                </span>
            </td>
        </tr>
    </table>
    <asp:GridView ID="wgvMaster" runat="server" AutoGenerateColumns="False" PageSize="15"
        Width="100%" CellPadding="5">
        <RowStyle BackColor="#EFF3FB" />
        <PagerSettings Mode="NumericFirstLast" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <Columns>
            <asp:BoundField DataField="EmployeeID" HeaderText="工号" SortExpression="EmployeeID" />
            <asp:BoundField DataField="EmpName" HeaderText="姓名" SortExpression="EmpName" />
            <asp:BoundField DataField="DepartmentName" HeaderText="部门" SortExpression="DepartmentName" />
            <asp:BoundField DataField="Month" HeaderText="月份" SortExpression="Month" />
            <asp:BoundField DataField="WorkOnDay" HeaderText="正常上班天数" SortExpression="WorkOnDay" />
            <asp:BoundField DataField="WorkOnDayAF" HeaderText="下午到天数" SortExpression="WorkOnDayAF" />
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="LightBlue" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="DeepSkyBlue" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" BorderColor="White" />
    </asp:GridView>
</asp:Content>
